|
|
| Author |
Thread Statistics | Show CCP posts - 12 post(s) |
Packet Loss
Minmatar
Rampage Eternal
   |
Posted - 2006.08.06 22:08:00 -
[1]
Hey guys/gals,
I have a couple of questions relating to the data export which I'm hoping some of my fellow pod pilots can assist with. I apologise if these questions are repeated but I have tried to find previous postings on them without success.
1. Missing drone images
I'm working on a killboard that parses the killmail and searches for the item name in invTypes, the graphicID field is being JOIN'd to the applicable record in eveGraphics and then I'm getting back the appropriate iconXX_YY.png filename to display for that item.
Unfortunately it appears none of the drones have a value in the icon field and thus I am unable to identify the correct iconXX_YY (or are these images even included in the latest icon librarys). There's the obvious manual fix for this but I'm hoping there's something I am missing?
I notice that this is even broken on the EVE-O Item Database in that when you display the T1 drone it's T2 variant's image is also broken, it produce exactly the same a href line my code does since it's unable to identify the icon number.
2. Generating EVE unvierse maps highlighting systems.
I've noticed a couple of killboards using some java script to generate an image of the EVE universe map highlighting systems in which the kill's were made.
I'd like to use this mechanism for some of my tools but have been unable to find any pointers on how this can be done, any help much appreciated.
Thanks in advance,
Packet
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 07:09:00 -
[2]
Ok thanks for the feedback!
Ynno, I knew I was missing something and now have my drone images based on the invTypes.typeID. I then of course had a similar issue with blueprints and without a simple way to identify the true type of the object (drone/bp/etc.) I dumped all the BP images (only available in 64x64) into the same folder as the drone images and used the same typeID method.
NOTE: The EVE-O team still need to fix this in the Item Database here :)
Ok I'm new to rendering images and am very happy if I don't have to touch Java (washing mouth out with soap ).
I understand I will need to render this image server side (it's not for the IGB remember) and will look into the tables today to figure out that would be done based on that data but any tips in the meantime would be much appreciated.
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 11:26:00 -
[3]
Ynno, thanks again.
I've been looking at this all morning and have reached the same conclusions you posted so its nice to get confirmation.
I am overlaying the dots onto the universe image from the data_map archive at the moment. I too am using PHP and GD, so far I've got the basics working but I'm struggling a bit with the maths.
So far so good ...
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 12:22:00 -
[4]
Ynno, ok now I'm really losing my mind on this.
It doesn't matter what I do I just can't seem to get the scaling to work properly. I'm using your scaling (250x250 with 10px border) but I can't seem to get the same values you posted.
Is there any chance you could post your PHP code for the float to x/y conversion?
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 13:53:00 -
[5]
Edited by: Packet Loss on 07/08/2006 13:53:11
 Originally by: Ynno
Well you don't need to convert the floating point numbers to integers with PHP and GD, I just mentioned rounding because I didn't know what platform you were working with at the time. I don't know exactly where you are having a problem, does
My first issue was I was converting the integers and not only losing precision but confusing myself in the process.
Originally by: Ynno
echo 0.00000000000000686344 * ( -1.07534933500286e+17 - -1.19198464346739e+17 ) + 10;
not print 90.051944152779441310485708527266979217529296875 for you?
It does print the same value.
Originally by: Ynno
The exact code I am using to plot a system in a constellation is:
imagefilledellipse ( $im,
$scale * ( $coords[0] - $xmin ) + $border + $xoffset,
$scale * ( $coords[1] - $ymin ) + $border + $yoffset,
4, 4,
$name == $highlight ? $white : $grey );
The $xoffset and $yoffset are for centring the narrowest axis as I mentioned at the bottom of my last post. $coords[0] and $coords[1] contain the x and z values unaltered from the database (that is still in exponential notation for most numbers). $xmin and $ymin contain the smallest values of x and z also in the same format as they are stored in the DB.
My problem seems to be the xmin/ymin values, how are you calculating these values exactly?
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 16:04:00 -
[6]
Edited by: Packet Loss on 07/08/2006 16:09:12
Originally by: Ynno
Edited by: Ynno on 07/08/2006 14:07:31
$xmin and $ymin are the smallest values of the x and z values of all the systems.
For example if I have 3 systems at the made up coordinates (23, 31), (13, 63), (54, 9) then xmin will be 13 (as it is the smallest x value) and ymin will be 9 (as it is the smallest z value - although I called it ymin as I find it less confusing that way).
Ok I'm getting different figures then because your only drawing a constellation and I'm trying to do the entire eve universe.
$xmin = (SELECT * FROM `mapSolarSystems` ORDER BY `x` ASC LIMIT 0,1)
$ymin = (SELECT * FROM `mapSolarSystems` ORDER BY `z` ASC LIMIT 0,1)
Thus my values are much higher in both directions, let me try this out and come back to you.
|
Packet Loss
Minmatar
Rampage Eternal
|
Posted - 2006.08.07 19:23:00 -
[7]
It never ceases to amaze me that something so simple appears so complicated upon first glance :)
I have everything working perfectly now and am generating perfect overlays, many thanks for your assistance.
|
|
|
| |
|